AQS
QA Re-engineering
Version 1.7
NADG
6/20/2013
This document contains the new delimited transactions to support the redesigned QA component of AQS.
QA Transactions
Contents
New Site / Monitor Transactions 4
MN Monitor Network Affiliation 5
QA Transactions For Monitors 8
QA 1-Point Quality Control (QC) 8
QA Annual Performance Evaluation (PE) 11
QA Semi-Annual Flow Rate Audit 15
Flow Rate Verification for PMc 17
Semi-Annual Flow Rate Audit for PMc 19
Performance Evaluation Program (PEP) 21
QA National Performance Audit Program 23
Field Proficiency Test (PT) 26
QA Lab Proficiency Test (PT) 32
QA Transactions For Verification of Standards 33
QA Ambient Air Protocol Gas Verification Program (AA-PGVP) 33
QA Ozone SRP and Ozone Transfer Standard Verifications (SRP) 34
QA Transactions Speciation Flow 36
2
3
Version |
Date |
Author |
Description |
1.0 |
12/4/2012 |
B.Frietsche |
Initial version |
1.1 |
12/4/2012 |
B.Frietsche |
Added version number |
1.2 |
12/11/2012 |
B.Frietsche |
removed equal signs from formatting rules re-ordered fields on Lab PT to consistent order |
1.3 |
12/11/2012 |
B.Frietsche |
Fixed transaction type formatting rule for transaction NM |
1.4 |
12/19/2012 |
B.Frietsche |
added flow verification and semi-annual flow rate audit for PM coarse, and split NPAP into NPAP-TTP and NPAP-BOA |
1.41 |
12/19/2012 |
B.Frietsche |
fixed version and date in doc |
1.42 |
2/11/2013 |
N. Mangus |
Added primary monitor period transaction (MO). Fixed one typo in MN transaction. |
1.6 |
6/5/2013 |
R. Coats |
(it is the performing agency)
AD – Site Sampler AE – Sampler Channel MP – Monitor Channel |
1.7 |
6/20/2013 |
R. Coats |
|
PMc is used to represent PM10-2.5 BOA = Back of Analyzer
TTP = Through the Probe
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘MM’ |
This is a Monitor Method transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
4 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor. If the previous field on the transaction contains “TT”, then the Tribal Code of the site. |
Always |
5 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county and/or tribe. |
Always |
6 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS |
Always |
7 |
POC |
Must exist in MONITORS table with Parameter |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Always |
8 |
Method Code |
Must exist in SAMPLING_METHODOLOGIES Reference table |
The sampling methodology (i.e. method of collection and analysis) implemented by monitor |
Always |
9 |
Begin Date |
Date in ‘YYYYMMDD’ format |
Beginning of date range where the monitor implements the specified method |
Always |
10 |
End Date |
Date in ‘YYYYMMDD’ format |
End of date range where the monitor implements the specified method |
Insert / Update |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘MN’ |
This is a Monitor Network Affiliation transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
4 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor. If the previous field on the transaction contains “TT”, then the Tribal Code of the site. |
Always |
5 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county and/or tribe. |
Always |
6 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS |
Always |
7 |
POC |
Must exist in MONITORS table with Parameter |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Always |
8 |
Network Name |
Must exist in AQS MONITORING_NETWORKS table. |
Monitoring network associated with monitor (e.g. NCORE, PAMS, NATTS) |
Always |
10 |
Begin Date |
Date in ‘YYYYMMDD’ format |
Beginning of date range where the monitor is affiliated with the specified network. |
Always |
11 |
End Date |
Date in ‘YYYYMMDD’ format |
End of date range where the monitor affiliated with the specified network. |
Insert / Update |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘MP’ |
This is a Primary Monitor Period transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
4 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor. If the previous field on the transaction contains “TT”, then the Tribal Code of the site. |
Always |
5 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county and/or tribe. |
Always |
6 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS |
Always |
7 |
POC |
Must exist in MONITORS table with Parameter |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Always |
8 |
Begin Date |
Date in ‘YYYYMMDD’ format |
Beginning of date range where the monitor is the primary for the parameter at the site. |
Always |
9 |
End Date |
Date in ‘YYYYMMDD’ format |
End of date range where the monitor the primary for the parameter at the site. |
Insert / Update |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘AD’ |
This is a Site-Sampler transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
4 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the site. If the previous field on the transaction contains “TT”, then the Tribal Code of the site. |
Always |
5 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county and/or tribe. |
Always |
6 |
Sampler ID |
Text String (limited to 20 Characters) |
The user assigned unique name or id for the sampler at the site (e.g. Speciation-1). |
Always |
7 |
Sampler Owner |
Must exist in AQS Agencies table |
Agency code of the agency that owns the sampler. |
Insert |
8 |
Manufacturer |
Text String (limited to 80 characters) |
Equipment manufacturer. |
Optional |
9 |
Model Number |
Text String (limited to 40 characters) |
Manufacturer’s model number. |
Optional |
10 |
Serial Number |
Text String (limited to 40 characters) |
Manufacturer’s serial number. |
Optional |
11 |
Channel Count |
Positive Number |
Number of distinct concurrent samples that can be taken by the sampler. |
Insert |
12 |
Begin Date |
Date in ‘YYYYMMDD’ format |
Beginning of date range where the sampler is in use at the site. |
Always |
13 |
End Date |
Date in ‘YYYYMMDD’ format |
End of date range where the sampler is in use at the site. |
Insert / Update |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘AE’ |
This is a Sampler-Channel transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
4 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the site. If the previous field on the transaction contains “TT”, then the Tribal Code of the site. |
Always |
5 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county and/or tribe. |
Always |
6 |
Sampler ID |
Must exist for Site in database |
The user’s unique name or id for the sampler at the site. |
Always |
7 |
Channel Number |
Positive Number; must be <= the channel count for the sampler |
Number assigned to channel on sampler |
Always |
8 |
Filter Type |
Must exist in AQS FILTER_TYPES table. |
Type of filter loaded into this channel in sampler (e.g. Quartz) |
Optional |
9 |
Target Flow Rate |
Positive number |
Nominal flow rate for channel |
Optional |
10 |
Flow Units |
Must exist in AQS Units table with unit type of “FLOW” |
Units code of target flow rate |
Required if Target Flow Rate not null |
11 |
Begin Date |
Date in ‘YYYYMMDD’ format |
Beginning of date range where the channel has the specified metadata. |
Always |
12 |
End Date |
Date in ‘YYYYMMDD’ format |
End of date range where the channel has the specified metadata. |
Insert / Update |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘MP’ |
This is a Primary Monitor Period transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
4 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor. If the previous field on the transaction contains “TT”, then the Tribal Code of the site. |
Always |
5 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county and/or tribe. |
Always |
6 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS |
Always |
7 |
POC |
Must exist in MONITORS table with Parameter |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Always |
8 |
Sampler ID |
Must exist for Site in database |
The user’s unique name or id for the sampler at the site. |
Always |
9 |
Channel Number |
Must be defined for Sampler in database |
Number assigned to channel on sampler |
Always |
10 |
Begin Date |
Date in ‘YYYYMMDD’ format |
Beginning of date range where the monitor is the primary for the parameter at the site. |
Always |
11 |
End Date |
Date in ‘YYYYMMDD’ format |
End of date range where the monitor the primary for the parameter at the site. |
Insert / Update |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “1-Point QC” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of organization performing assessment |
Optional (default to user agency) |
5 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor being assessed, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
6 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor being assessed. If the previous field on the transaction contains “TT”, then the Tribal Code of the site being assessed. |
Always |
7 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county. |
Always |
8 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS for which the assessment is being performed |
Always |
9 |
POC |
Must exist in MONITORS table with Parameter |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Always |
10 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
11 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional same assessments are performed. |
Always |
12 |
Monitor Method Code |
Must exist in SAMPLING_METHODOLOGIES Reference table |
The sampling methodology of the monitor being assessed. |
Insert |
13 |
Reported Unit |
Must exist in UNITS Reference table, and unit code must be for “Concentration” units type |
Units associated with the assessment concentrations (Monitor Concentration and Check Standard Concentration) |
Insert / Update |
14 |
Monitor |
Number (unrestricted) |
The concentration value provided by |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
|
Concentration |
|
the monitor being assessed. |
|
15 |
Assessment Concentration |
Number (unrestricted) |
The value of the known gas standard concentration. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “Annual PE” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of organization performing assessment |
Optional (default to user agency) |
5 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor being assessed, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
6 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor being assessed. If the previous field on the transaction contains “TT”, then the Tribal Code of the site being assessed. |
Always |
7 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county. |
Always |
8 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS for which the assessment is being performed |
Always |
9 |
POC |
Must exist in MONITORS table with Parameter |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Always |
10 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
11 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional same assessments are performed. |
Always |
12 |
Monitor Method Code |
Must exist in SAMPLING_METHODOLOGIES Reference table |
The sampling methodology of the monitor being assessed. |
Insert |
13 |
Reported Unit |
Must exist in UNITS Reference table, and unit code must be for “Concentration” units type |
Units associated with the assessment concentrations (Monitor Concentration and Check Standard Concentration) |
Insert / Update |
14 |
Level 1 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 1. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
15 |
Level 1 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 1. |
Insert |
16 |
Level 2 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 2. |
Insert |
17 |
Level 2 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 2. |
Insert |
18 |
Level 3 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 3. |
Insert |
19 |
Level 3 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 3. |
Insert |
20 |
Level 4 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 4. |
Insert |
21 |
Level 4 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 4. |
Insert |
22 |
Level 5 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 5. |
Insert |
23 |
Level 5 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 5. |
Insert |
24 |
Level 6 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 6. |
Insert |
25 |
Level 6 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 6. |
Insert |
26 |
Level 7 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 7. |
Insert |
27 |
Level 7 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 7. |
Insert |
28 |
Level 8 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 8. |
Insert |
29 |
Level 8 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 8. |
Insert |
30 |
Level 9 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
|
|
|
9. |
|
31 |
Level 9 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 9. |
Insert |
32 |
Level 10 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 01. |
Insert |
33 |
Level 10 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 10. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “Flow Rate V” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of organization performing assessment |
Optional (default to user agency) |
5 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor being assessed, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
6 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor being assessed. If the previous field on the transaction contains “TT”, then the Tribal Code of the site being assessed. |
Always |
7 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county. |
Always |
8 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS for which the assessment is being performed |
Always |
9 |
POC |
Must exist in MONITORS table with Parameter |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Always |
10 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
11 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional same assessments are performed. |
Always |
12 |
Monitor Method Code |
Must exist in SAMPLING_METHODOLOGIES Reference table |
The sampling methodology of the monitor being assessed. |
Insert |
13 |
Reported Unit |
Must exist in UNITS Reference table, and unit code must be for “Flow’ units type |
Units associated with the assessment |
Insert / Update |
14 |
Monitor Flow Rate |
Number (unrestricted) |
The measured flow rate provided by the monitor being assessed. |
Insert |
15 |
Assessment Flow Rate |
Number (unrestricted) |
The flow rate of the flow transfer standard |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “Semi Annual Flow Rate Audit” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of organization performing assessment |
Optional (default to user agency) |
5 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor being assessed, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
6 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor being assessed. If the previous field on the transaction contains “TT”, then the Tribal Code of the site being assessed. |
Always |
7 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county. |
Always |
8 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS for which the assessment is being performed |
Always |
9 |
POC |
Must exist in MONITORS table with Parameter |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Always |
10 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
11 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional same assessments are performed. |
Always |
12 |
Monitor Method Code |
Must exist in SAMPLING_METHODOLOGIES Reference table |
The sampling methodology of the monitor being assessed. |
Insert |
13 |
Reported Unit |
Must exist in UNITS Reference table, and unit code must be for “Flow’ units type |
Units associated with the assessment |
Insert / Update |
14 |
Monitor Flow Rate |
Number (unrestricted) |
The measured flow rate provided by the monitor being assessed. |
Insert |
15 |
Assessment Flow |
Number (unrestricted) |
The flow rate of the flow transfer |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
|
Rate |
|
standard. |
|
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “PMc Flow Rate V” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of organization performing assessment |
Optional (default to user agency) |
5 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor being assessed, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
6 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor being assessed. If the previous field on the transaction contains “TT”, then the Tribal Code of the site being assessed. |
Always |
7 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county. |
Always |
8 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS for which the assessment is being performed |
Always |
9 |
POC |
Must exist in MONITORS table with Parameter |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Always |
10 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
11 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional same assessments are performed. |
Always |
12 |
Reported Unit |
Must exist in UNITS Reference table, and unit code must be for “Flow’ units type |
Units associated with the assessment |
Insert / Update |
13 |
PM10 Monitor Method Code |
Must exist in SAMPLING_METHODOLOGIES Reference table |
The sampling methodology of the PM10 monitor being assessed. |
Insert |
14 |
PM10 Monitor Flow Rate |
Number (unrestricted) |
The measured flow rate provided by the monitor being assessed. |
Insert |
15 |
PM10 Assessment Flow |
Number (unrestricted) |
The flow rate of the flow transfer standard. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
|
Rate |
|
|
|
16 |
PM 2.5 Monitor Method Code |
Must exist in SAMPLING_METHODOLOGIES Reference table |
The sampling methodology of the PM 2.5 monitor being assessed. |
Insert |
17 |
PM 2.5 Monitor Flow Rate |
Number (unrestricted) |
The measured flow rate provided by the monitor being assessed. |
Insert |
18 |
PM 2.5 Assessment Flow Rate |
Number (unrestricted) |
The flow rate of the flow transfer standard. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “PMc Semi Annual Flow Rate Audit” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of organization performing assessment |
Optional (default to user agency) |
5 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor being assessed, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
6 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor being assessed. If the previous field on the transaction contains “TT”, then the Tribal Code of the site being assessed. |
Always |
7 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county. |
Always |
8 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS for which the assessment is being performed |
Always |
9 |
POC |
Must exist in MONITORS table with Parameter |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Always |
10 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
11 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional same assessments are performed. |
Always |
12 |
Reported Unit |
Must exist in UNITS Reference table, and unit code must be for “Flow’ units type |
Units associated with the assessment |
Insert / Update |
13 |
PM10 Monitor Method Code |
Must exist in SAMPLING_METHODOLOGIES Reference table |
The sampling methodology of the monitor being assessed. |
Insert |
14 |
PM10 Monitor Flow Rate |
Number (unrestricted) |
The measured flow rate provided by the monitor being assessed. |
Insert |
15 |
PM10 Assessment Flow |
Number (unrestricted) |
The flow rate of the flow transfer standard. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
|
Rate |
|
|
|
16 |
PM 2.5 Monitor Method Code |
Must exist in SAMPLING_METHODOLOGIES Reference table |
The sampling methodology of the monitor being assessed. |
Insert |
17 |
PM 2.5 Monitor Flow Rate |
Number (unrestricted) |
The measured flow rate provided by the monitor being assessed. |
Insert |
18 |
PM 2.5 Assessment Flow Rate |
Number (unrestricted) |
The flow rate of the flow transfer standard. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “PEP” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of organization performing assessment |
Optional (default to user agency) |
5 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor being assessed, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
6 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor being assessed. If the previous field on the transaction contains “TT”, then the Tribal Code of the site being assessed. |
Always |
7 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county. |
Always |
8 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS for which the assessment is being performed |
Always |
9 |
POC |
Must exist in MONITORS table with Parameter |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Always |
10 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
11 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional same assessments are performed. |
Always |
12 |
PEP Type |
Literal: “INDEPENDENT” or “COLLOCATED” |
Indicates where the PEP monitor is operated by the Audit Agency or by the Monitoring Agency. |
Insert |
13 |
Monitor Method Code |
Must exist in SAMPLING_METHODOLOGIES Reference table |
The sampling methodology of the monitor being assessed. |
Insert |
14 |
Reported Unit |
Must exist in UNITS Reference table, and unit code must be for “Concentration” units type |
Units associated with the assessment concentration |
Insert / Update |
15 |
Assessment |
Number (unrestricted) |
The value reported by the PEP |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
|
Concentration |
|
monitor for the Date-Time. |
|
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “NPAP” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of organization performing assessment |
Optional (default to user agency) |
5 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor being assessed, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
6 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor being assessed. If the previous field on the transaction contains “TT”, then the Tribal Code of the site being assessed. |
Always |
7 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county. |
Always |
8 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS for which the assessment is being performed |
Always |
9 |
POC |
Must exist in MONITORS table with Parameter |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Always |
10 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
11 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional same assessments are performed. |
Always |
12 |
NPAP_Type |
Literal: “TTP” or “BOA” |
Code meaning “Through the probe” or “Back of analyzer” |
Insert |
13 |
Monitor Method Code |
Must exist in SAMPLING_METHODOLOGIES Reference table |
The sampling methodology of the monitor being assessed. |
Insert |
14 |
Assessment Method Code |
Must exist in SAMPLING_METHODOLOGIES Reference table |
For parameters other than Ozone, this is the method code of the CO monitor used to determine check |
Conditional on Insert (not |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
|
|
|
gas dilution. |
ozone) |
15 |
Reported Unit |
Must exist in UNITS Reference table, and unit code must be for “Concentration” units type |
Units associated with the assessment concentrations (Monitor Concentration and Check Standard Concentration) |
Insert / Update |
16 |
Level 1 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 1. |
Insert |
17 |
Level 1 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 1. |
Insert |
18 |
Level 2 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 2. |
Insert |
19 |
Level 2 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 2. |
Insert |
20 |
Level 3 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 3. |
Insert |
21 |
Level 3 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 3. |
Insert |
22 |
Level 4 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 4. |
Insert |
23 |
Level 4 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 4. |
Insert |
24 |
Level 5 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 5. |
Insert |
25 |
Level 5 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 5. |
Insert |
26 |
Level 6 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 6. |
Insert |
27 |
Level 6 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 6. |
Insert |
28 |
Level 7 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 7. |
Insert |
29 |
Level 7 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 7. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
30 |
Level 8 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 8. |
Insert |
31 |
Level 8 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 8. |
Insert |
32 |
Level 9 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 9. |
Insert |
33 |
Level 9 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 9. |
Insert |
34 |
Level 10 Monitor Concentration |
Number |
The concentration value provided by the monitor being assessed at level 10. |
Insert |
35 |
Level 10 Assessment Concentration |
Number |
The value of the known gas standard concentration in Audit Level 10. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “Field Proficiency Test ” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of organization performing assessment |
Optional (default to user agency) |
5 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor being assessed, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
6 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor being assessed. If the previous field on the transaction contains “TT”, then the Tribal Code of the site being assessed. |
Always |
7 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county. |
Always |
8 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS for which the assessment is being performed |
Always |
9 |
POC |
Must exist in MONITORS table with Parameter |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Always |
10 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
11 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional same assessments are performed. |
Always |
12 |
Monitor Method Code |
Must exist in SAMPLING_METHODOLOGIES Reference table |
The sampling methodology of the monitor being assessed. |
Insert |
13 |
Reported Unit |
Must exist in UNITS Reference table, and unit code must be for “Concentration” units type |
Units associated with the assessment concentrations (Monitor Concentration and Check Standard Concentration) |
Insert / Update |
14 |
Monitor Concentration |
Number (unrestricted) |
The concentration value provided by the monitor being assessed. |
Insert |
15 |
Assessment |
Number (unrestricted) |
The known value of the analyte |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
|
Concentration |
|
concentration. |
|
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “Duplicate” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of organization performing assessment |
Optional (default to user agency) |
5 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor being assessed, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
6 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor being assessed. If the previous field on the transaction contains “TT”, then the Tribal Code of the site being assessed. |
Always |
7 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county. |
Always |
8 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS for which the assessment is being performed |
Always |
9 |
POC |
Must exist in MONITORS table with Parameter |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Always |
10 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
11 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional same assessments are performed. |
Always |
12 |
Monitor Method Code |
Must exist in SAMPLING_METHODOLOGIES Reference table |
The sampling methodology of the monitor being assessed. |
Insert |
13 |
Reported Unit |
Must exist in UNITS Reference table, and unit code must be for “Concentration” units type |
Units associated with the assessment concentrations (Monitor Concentration and Check Standard Concentration) |
Insert / Update |
14 |
Duplicate Value 1 |
Number (unrestricted) |
The concentration value provided by the monitor being assessed. |
Insert |
15 |
Duplicate Value 2 |
Number (unrestricted) |
The concentration value provided by |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
|
|
|
the monitor being assessed. |
|
16 |
Duplicate Value 3 |
Number (unrestricted) |
The concentration value provided by the monitor being assessed. |
Insert |
17 |
Duplicate Value 4 |
Number (unrestricted) |
The concentration value provided by the monitor being assessed. |
Insert |
18 |
Duplicate Value 5 |
Number (unrestricted) |
The concentration value provided by the monitor being assessed. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “Replicate” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of organization performing assessment |
Optional (default to user agency) |
5 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the monitor being assessed, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
6 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor being assessed. If the previous field on the transaction contains “TT”, then the Tribal Code of the site being assessed. |
Always |
7 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county. |
Always |
8 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS for which the assessment is being performed |
Always |
9 |
POC |
Must exist in MONITORS table with Parameter |
Parameter Occurrence Code: One or two digit number identifying a specific monitor for a parameter at the site. |
Always |
10 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
11 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional same assessments are performed. |
Always |
12 |
Monitor Method Code |
Must exist in SAMPLING_METHODOLOGIES Reference table |
The sampling methodology of the monitor being assessed. |
Insert |
13 |
Reported Unit |
Must exist in UNITS Reference table, and unit code must be for “Concentration” units type |
Units associated with the assessment concentrations (Monitor Concentration and Check Standard Concentration) |
Insert / Update |
14 |
Replicate Value 1 |
Number (unrestricted) |
The concentration value provided by the monitor being assessed. |
Insert |
15 |
Replicate Value 2 |
Number (unrestricted) |
The concentration value provided by |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
|
|
|
the monitor being assessed. |
|
16 |
Replicate Value 3 |
Number (unrestricted) |
The concentration value provided by the monitor being assessed. |
Insert |
17 |
Replicate Value 4 |
Number (unrestricted) |
The concentration value provided by the monitor being assessed. |
Insert |
18 |
Replicate Value 5 |
Number (unrestricted) |
The concentration value provided by the monitor being assessed. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “Pb Analysis Audit ” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of laboratory performing assessment (analysis of strips) |
Always |
5 |
Primary Quality Assurance Organization |
Must exist in AGENCIES Reference Table |
Agency Code of organization responsible for the quality of data for Monitoring Organization |
Always |
6 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS for which the assessment is being performed |
Always |
7 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
8 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional same assessments are performed. |
Always |
9 |
Reported Unit |
Must be literal ‘077’ (micrograms) |
Units for mass of lead on test strip. Required by Part 58.3.3.4.(c) to be this unit code. |
Insert / Update |
10 |
Laboratory Response Value 1 |
Number (unrestricted) |
The mass of lead reported by lab for level 1. |
Insert |
11 |
Assessment Mass 1 |
Number (Must be in range of mass values for audit level 1 in AUDIT_LEVELS able in database) |
The known mass of lead on the test strip for level 1. |
Insert |
12 |
Laboratory Response Value 2 |
Number (unrestricted) |
The mass of lead reported by lab for level 2. |
Insert |
13 |
Assessment Mass 2 |
Number (Must be in range of mass values for audit level 2 in AUDIT_LEVELS able in database) |
The known mass of lead on the test strip for level 2. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “Lab Proficiency Test ” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of laboratory performing assessment (analysis of strips) |
Always |
5 |
Primary Quality Assurance Organization |
Must exist in AGENCIES Reference Table |
Agency Code of organization responsible for the quality of data for Monitoring Organization |
Always |
6 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code assigned to the monitor in AQS for which the assessment is being performed |
Always |
7 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
8 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional same assessments are performed. |
Always |
9 |
Reported Unit |
Must exist in UNITS Reference table |
Units of measure of analyte by Lab. |
Insert / Update |
10 |
Laboratory Response Value 1 |
Number (unrestricted) |
The mass of analyte reported by Lab. |
Insert |
11 |
Assessment Mass 1 |
Number |
The known mass of analyte on the test media. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “AA-PGVP ” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of organization performing assessment (Regional Analytical Verification Laboratory) |
Always |
5 |
Producer ID |
Must exist in AAPGVP_PRODUCERS Reference Table |
Unique identifier of organization that produced cylinder being assessed. |
Always |
6 |
Cylinder ID |
Text string (limited to 40 character) |
Unique identifier (e.g. serial number) of gas cylinder being assessed. |
Always |
7 |
Parameter Code |
Must exist in PARAMETERS Reference Table |
The AQS parameter code of check gas in cylinder |
Always |
8 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
9 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. |
Always |
10 |
Reported Unit |
Must exist in UNITS Reference table, and unit code must be for “Concentration” units type |
Units of measure of cylinder gas. |
Insert / Update |
11 |
Cylinder certified concentration |
Positive Number |
Gas concentration specified by cylinder producer. |
Insert |
12 |
Assessment Concentration |
Positive Number |
Measured concentration of gas in cylinder. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “Ozone-SRP” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Verification Type |
Literal: “6X6” or “Standard” |
“6X6” is for the initial verification of a new standard ozone generator. “Standard” is for a routine SRP assessment. |
Always |
5 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of organization performing assessment |
Always |
6 |
Primary Quality Assurance Organization |
Must exist in AGENCIES Reference Table |
Agency Code of organization responsible for the quality of instrument being assessed. |
Always |
7 |
Parameter Code |
Literal “44201” |
The AQS parameter code |
Always |
8 |
Authoritative standard ID |
Must exist on SRP_STANDARDS Reference Table |
Unique ID for Authoritative standard. |
Always |
9 |
Authoritative Standard Level |
Number; must be 1, 2, or 3. |
Primary EPA standard is Level 1, those validated against it are level 2, and those validated against level 2 standards are level 3. |
Always |
10 |
Transfer standard ID |
Text string (limited to 40 character) |
Unique ID code (serial number) for transfer standard |
Always |
11 |
Transfer Standard Level |
Number; must be >= authoritative standard. |
Level 1, 2, 3, 4 transfer standard has to be equal or a higher number then the Authoritative Standard |
Always |
12 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
13 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional assessments are performed. |
Always |
14 |
Reported Unit |
Must exist in UNITS Reference table, and unit code must be for “Concentration” units type |
Units associated with the assessment concentrations (Monitor Concentration and Check Standard Concentration) |
Insert / Update |
15 |
Transfer Standard Value 1 |
Number |
Measurement from instrument being assessed. |
Insert |
16 |
Authoritative Standard Value1 |
Number |
Measurement from authoritative standard instrument. |
Insert |
17 |
Transfer Standard Value 2 |
Number |
Measurement from instrument being assessed. |
Insert |
18 |
Authoritative Standard Value2 |
Number |
Measurement from authoritative standard instrument. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
19 |
Transfer Standard Value 3 |
Number |
Measurement from instrument being assessed. |
Insert |
20 |
Authoritative Standard Value3 |
Number |
Measurement from authoritative standard instrument. |
Insert |
21 |
Transfer Standard Value 4 |
Number |
Measurement from instrument being assessed. |
Insert |
22 |
Authoritative Standard Value4 |
Number |
Measurement from authoritative standard instrument. |
Insert |
23 |
Transfer Standard Value 5 |
Number |
Measurement from instrument being assessed. |
Insert |
24 |
Authoritative Standard Value5 |
Number |
Measurement from authoritative standard instrument. |
Insert |
25 |
Transfer Standard Value 6 |
Number |
Measurement from instrument being assessed. |
Insert |
26 |
Authoritative Standard Value6 |
Number |
Measurement from authoritative standard instrument. |
Insert |
27 |
Transfer Standard Value 7 |
Number |
Measurement from instrument being assessed. |
Insert |
28 |
Authoritative Standard Value7 |
Number |
Measurement from authoritative standard instrument. |
Insert |
29 |
Transfer Standard Value 8 |
Number |
Measurement from instrument being assessed. |
Insert |
30 |
Authoritative Standard Value8 |
Number |
Measurement from authoritative standard instrument. |
Insert |
31 |
Transfer Standard Value 9 |
Number |
Measurement from instrument being assessed. |
Insert |
32 |
Authoritative Standard Value9 |
Number |
Measurement from authoritative standard instrument. |
Insert |
33 |
Transfer Standard Value 10 |
Number |
Measurement from instrument being assessed. |
Insert |
34 |
Authoritative Standard Value10 |
Number |
Measurement from authoritative standard instrument. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “Speciation Flow Rate V ” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of organization performing assessment |
Optional
|
5 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the site being assessed, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
6 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor being assessed. If the previous field on the transaction contains “TT”, then the Tribal Code of the site being assessed. |
Always |
7 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county and/or tribe. |
Always |
8 |
Sampler ID |
Must exist for Site in database |
The user’s unique name or id for the sampler at the site. |
Always |
9 |
Channel Number |
Must be defined for Sampler in database |
Number assigned to channel on sampler |
Always |
10 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
11 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional same assessments are performed. |
Always |
12 |
Reported Unit |
Must exist in UNITS Reference table, and unit code must be for “Flow” units type |
Units associated with the flow values |
Insert / Update |
13 |
Sampler Flow Rate |
Number (unrestricted) |
The measured flow rate provided by the sampler being assessed. |
Insert |
14 |
Assessment Flow Rate |
Number (unrestricted) |
The flow rate of the flow transfer standard. |
Insert |
Field # |
Field Name |
Formatting Rule |
Field Description |
When Reqd |
1 |
Transaction Type |
Literal: ‘QA’ |
This is a Quality Assurance transaction. |
Always |
2 |
Action Indicator |
{‘I’, ‘U’. D’, or ‘R’} |
Indicator for Insert, Update, Delete, or Replace action. |
Always |
3 |
Assessment Type |
Literal: “Speciation Flow Rate Audit ” |
Indicates the specific QA assessment associated with the transaction. |
Always |
4 |
Performing Agency |
Must exist in AGENCIES Reference Table |
Agency Code of organization performing assessment |
Optional
|
5 |
State Code / Tribal Indicator |
Must exist in STATES Reference Table or be ‘TT’ for Tribal Site |
The FIPS state code of the site being assessed, or “TT” to indicate that the next field on the transaction is a Tribal code. |
Always |
6 |
County Code / Tribal Code |
Must exist in COUNTIES (for state) or TRIBAL_AREAS Reference table
|
The FIPS County Code of the monitor being assessed. If the previous field on the transaction contains “TT”, then the Tribal Code of the site being assessed. |
Always |
7 |
Site number |
Must exist in SITES table with {State Code, county Code} or Tribal Code |
Four digit number to uniquely identify site in county and/or tribe. |
Always |
8 |
Sampler ID |
Must exist for Site in database |
The user’s unique name or id for the sampler at the site. |
Always |
9 |
Channel Number |
Must be defined for Sampler in database |
Number assigned to channel on sampler |
Always |
10 |
Assessment Date |
Date in YYYYMMDD format |
Date that the assessment was performed |
Always |
11 |
Assessment Number |
Positive Number |
A unique number associated with an assessment performed at a site on a given day. Value should be “1” unless additional assessments are performed. |
Always |
12 |
Reported Unit |
Must exist in UNITS Reference table, and unit code must be for “Flow” units type |
Units associated with the flow values |
Insert / Update |
13 |
Sampler Flow Rate |
Number (unrestricted) |
The measured flow rate provided by the sampler being assessed. |
Insert |
14 |
Assessment Flow Rate |
Number (unrestricted) |
The flow rate of the flow transfer standard. |
Insert |